SHOW FULL COLUMNS FROM `mtr_bus_route` [ RunTime:0.000456s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-521-O-0' LIMIT 1 [ RunTime:0.000240s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-521-O-0' LIMIT 1 [ RunTime:0.000196s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-521-I-0' LIMIT 1 [ RunTime:0.000220s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-521-I-0' LIMIT 1 [ RunTime:0.011127s ]
SHOW FULL COLUMNS FROM `mtr_bus_stop` [ RunTime:0.000411s ]
SELECT `id`,`name` FROM `mtr_bus_stop` WHERE `id` IN ('RMB-37173','RMB-37178','RMB-37179','RMB-37182','RMB-37184','RMB-37185','RMB-37186') [ RunTime:0.000257s ]
SELECT `id`,`no`,`co`,`name`,`stop_list`,`orig`,`dest` FROM `mtr_bus_route` `r` WHERE `r`.`bound` = 'O' AND ( JSON_CONTAINS(stop_list, '"RMB-37173"') ) LIMIT 10 [ RunTime:0.081375s ]